<?
require_once("../config/dbconn.php");require_once("../config/powercls.php");require_once("../config/pagecls.php");

if($action=='del'){
	$sql="select * from {$db_prefix}tixian where id='$id'";
	$rs=$db->get_one($sql);
	if ($rs['state']==0){
		//返还会员金额
		$sqlhy="select * from {$db_prefix}users where username='".$rs['username']."'";
		$rshy=$db->get_one($sqlhy);
		//拒绝提现
		$sqlkk="update {$db_prefix}users set jjprice=jjprice+'".floatval($rs['price'])."' where username='".$rs['username']."'";
		$db->query($sqlkk);
		//财务记录
		$e_userid=$rshy['id'];$e_price=floatval($rs['price']);$e_type=5;$e_ptype=3;$e_addtime=$curtime;$e_memo="拒绝 奖金币提现";
		hyepricejl($e_userid,$e_price,$e_type,$e_ptype,$e_addtime,$e_memo);
	}
	$db->delete("{$db_prefix}tixian","id='$id'");
		
	echo "<script>location.href='tixian_lst.php?pageno={$pageno}';</script>";exit();
}

if($action=='isok'){
	$sql="select * from {$db_prefix}tixian where id='$id'";
	$rs=$db->get_one($sql);
	if ($rs['state']!=0){
		$msg="提现状态错误\\n";
	}
	if ($msg!=''){
		echo "<script>alert('$msg');history.back();</script>";exit();
	}
	unset($dataArray);
	$dataArray['state']=1;
	$dataArray['edittime']=$curtime;
	$db->update("{$db_prefix}tixian",$dataArray,"id='$id'");
	echo "<script>location.href='tixian_lst.php?pageno={$pageno}';</script>";exit();
}

if($action=='isno'){
	$sql="select * from {$db_prefix}tixian where id='$id'";
	$rs=$db->get_one($sql);
	if ($rs['state']!=0){
		$msg="提现状态错误\\n";
	}
	if ($msg!=''){
		echo "<script>alert('$msg');history.back();</script>";exit();
	}
	//返还会员金额
	$sqlhy="select * from {$db_prefix}users where username='".$rs['username']."'";
	$rshy=$db->get_one($sqlhy);
	//拒绝提现
	$sqlkk="update {$db_prefix}users set jjprice=jjprice+'".floatval($rs['price'])."' where username='".$rs['username']."'";
	$db->query($sqlkk);
	//财务记录
	$e_userid=$rshy['id'];$e_price=floatval($rs['price']);$e_type=5;$e_ptype=3;$e_addtime=$curtime;$e_memo="拒绝 奖金币提现";
	hyepricejl($e_userid,$e_price,$e_type,$e_ptype,$e_addtime,$e_memo);
	
	unset($dataArray);
	$dataArray['state']=2;
	$dataArray['edittime']=$curtime;
	$db->update("{$db_prefix}tixian",$dataArray,"id='$id'");
	echo "<script>location.href='tixian_lst.php?pageno={$pageno}';</script>";exit();
}

if($action=='agreeall'){
	foreach($idok as $id){
		$sql="select * from {$db_prefix}tixian where id='$id'";
		$rs=$db->get_one($sql);
		if ($rs['state']!=0){
			$msg="提现状态错误\\n";
		}else{
			/*if ($msg!=''){
				echo "<script>alert('$msg');history.back();</script>";exit();
			}*/
			unset($dataArray);
			$dataArray['state']=1;
			$dataArray['edittime']=$curtime;
			$db->update("{$db_prefix}tixian",$dataArray,"id='$id'");
		}
	}
	echo "<script>location.href='tixian_lst.php?pageno={$pageno}';</script>";exit();
}


 $query='';$querystr='?action=query';
  if ($action=='query'){
  	if (trim($username)!='') $query.=" and username='".trim($username)."'";
	if (trim($price1)!='') $query.=" and price>='".trim($price1)."'";
	if (trim($price2)!='') $query.=" and price<='".trim($price2)."'";
	if (trim($state)!='') $query.=" and state='".trim($state)."'";
	if (trim($time1)!='') $query.=" and addtime>='".strtotime($time1)."'";
	if (trim($time2)!='') $query.=" and addtime<='".(strtotime($time1)+24*3600)."'";
	foreach($_POST as $k1=>$v1){
		if ($querystr!="") $querystr.='&';$querystr.="{$k1}=".urlencode($v1);
	}
 }
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="javascript" type="text/javascript" src="../calendar/WdatePicker.js"></script>
<script language="javascript">
function SelectAll() {
 var checkboxs=document.getElementsByName("idok[]");
 for (var i=0;i<checkboxs.length;i++) {
  var e=checkboxs[i];
  e.checked=!e.checked;
 }
}

 </script> 

</script>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	
}
td{
font-size:12px;
}
-->
</style>

<link href="images/skin.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.red {	color:#FF0000
}
-->
</style>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="17" height="29" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
    <td width="935" height="29" valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
      <tr>
        <td height="31"><div class="titlebt"> 奖金币提现管理</div></td>
      </tr>
    </table></td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
  </tr>
  <tr>
    <td height="71" valign="middle" background="images/mail_leftbg.gif">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9"><table width="100%" height="138" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="13" align="center" valign="top"><a href="../excel/tixian_lst1.php<?=$querystr?>">导出excel</a></td>
      </tr>
      <tr>
        <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="nowtable">
                <tr>
                  <td align="center" class="left_bt2"><form name="form1" method="post" action="?action=query">
                    会员：
                    <label>
      <input name="username" type="text" id="username" size="8">
      </label>
                    状态:
	<label>
  <select name="state" id="state">
    <option value="">全部状态</option>
    <option value="0">等待审核</option>
    <option value="1">提现成功</option>
    <option value="2">提现失败</option>
  </select>
  </label>
                    金额：
  <label>
  <input name="price1" type="text" id="price1" size="5">
  </label>
                    -
  <label>
  <input name="price2" type="text" id="price2" size="5">
  </label>
                    时间：
  <label>
  <input name="time1" type="text" id="time1" size="8" onClick="WdatePicker()">
  </label>
                    -
  <input name="time2" type="text" id="time2" size="8" onClick="WdatePicker()">
  <label>
  <input type="submit" name="Submit" value="查询">
  </label>
                                    </form></td>
                </tr>
              </table></td>
            </tr>
            <tr>
              <td height="30"><form name="myform" method="post" action="?action=agreeall">
                <table width="100%" height="60" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td height="30" align="center" bgcolor="#f2f2f2" >编号</td>
                    <td align="center" bgcolor="#f2f2f2" >用户名</td>
                    <td align="center" bgcolor="#f2f2f2" >银行</td>
                    <td align="center" bgcolor="#f2f2f2" >银行地址</td>
                    <td align="center" bgcolor="#f2f2f2" >卡号</td>
                    <td align="center" bgcolor="#f2f2f2" >开户名</td>
                    <td align="center" bgcolor="#f2f2f2" >金额</td>
                    <td align="center" bgcolor="#f2f2f2" >费用</td>
                    <td align="center" bgcolor="#f2f2f2" >实际金额</td>
                    <td align="center" bgcolor="#f2f2f2" >状态</td>
                    <td align="center" bgcolor="#f2f2f2" >申请时间</td>
                    <td align="center" bgcolor="#f2f2f2" >审核时间</td>
                    <td height="30" align="center" bgcolor="#f2f2f2" >操作</td>
                  </tr>
                  <?
 
  $sql="select count(id) as c  from {$db_prefix}tixian where 1";
  if ($query!='') $sql.=$query;
  $rs=$db->get_one($sql);
  $page=new pagecls(20,intval($rs['c']));
  $sql="select * from {$db_prefix}tixian where 1";
  if ($query!='') $sql.=$query;
  $sql.=" order by id desc limit {$page->pastnum},{$page->pagesize}";
  $result=$db->query($sql);
  while($rs=$db->fetch_array($result)){
  ?>
                  <tr>
                    <td align="center"><label>
                      <input type="checkbox" name="idok[]" value="<?=$rs['id']?>">
                      </label>
                        <?=$rs['id']?></td>
                    <td align="center"><?=$rs['username']?></td>
                    <td align="center"><?=$rs['bank']?>
                    </td>
                    <td align="center" ><?=$rs['bankaddress']?></td>
                    <td align="center" ><?=$rs['bankno']?></td>
                    <td align="center" ><?=$rs['bankname']?></td>
                    <td align="center" ><?=$rs['price']?></td>
                    <td align="center" class="red" ><?=$rs['feiyong']?></td>
                    <td align="center" class="left_txt3" ><?=$rs['price']-$rs['feiyong']?></td>
                    <td align="center" class="left_txt3" ><? if ($rs['state']==0) echo "等待审核";elseif ($rs['state']==1) echo "提现成功";elseif($rs['state']==2) echo "提现失败";?></td>
                    <td align="center" ><?=date("Y-m-d H:i:s",$rs['addtime'])?></td>
                    <td align="center" ><? if ($rs['edittime']>0) echo date("Y-m-d H:i:s",$rs['edittime'])?></td>
                    <td height="30" align="center" ><a href="tixian_view.php?id=<?=$rs['id']?>&pageno=<?=$page->pageno?>">查看</a>|
                      <?
				  if ($rs['state']==0){
				  ?>
                        <a href="?action=isok&id=<?=$rs['id']?>&pageno=<?=$page->pageno?>" onClick='return confirm("确定审核吗？\r一旦审核就会给会员进行银行打款")'>审核</a>|<a href="?action=isno&id=<?=$rs['id']?>&pageno=<?=$page->pageno?>" onClick="return confirm('确定拒绝吗？')">拒绝</a>|
                      <?
				  }
				  ?>
                      <a href="?action=del&id=<?=$rs['id']?>&pageno=<?=$page->pageno?>">删除</a></td>
                  </tr>
                  <?
  }
  $db->free_result($result);
  ?>
                </table>
                <input type="submit" name="chkAll" value="审核选定">
                <label>
                <input type="checkbox" name="checkbox" value="1" onclick='SelectAll()'>
                </label>
                            </form>
              <label></label></td>
            </tr>
            
            <tr></tr>
            <tr>
              <td height="30" align="right">每页<?=$page->pagesize?>条 第<?=$page->pageno?>/<?=$page->pagenum?>页 共<?=$page->recnum?>条 <a href='?<?=$page->url?>1'><img src="image1/first.gif" border="0"></a>   <a href='?<?=$page->url.($page->pageno-1)?>'><img src="image1/back.gif" border="0"></a>  <a href='?<?=$page->url.($page->pageno+1)?>'><img src="image1/next.gif" border="0"></a>   <a href='?<?=$page->url.$page->pagenum?>'><img src="image1/last.gif" border="0"></a></td>
              </tr>
            <tr>
              <td height="30">&nbsp;</td>
            </tr>
          </table></td>
      </tr>
    </table></td>
    <td background="images/mail_rightbg.gif">&nbsp;</td>
  </tr>
  <tr>
    <td valign="middle" background="images/mail_leftbg.gif"><img src="images/buttom_left2.gif" width="17" height="17" /></td>
      <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td>
    <td background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td>
  </tr>
</table>

</body>
</html>
